SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlAsignaturasGenericas
AS
SELECT     dbo.tb_AsignaturasGenericas.idAsignaturaGenerica AS ID, dbo.tb_AsignaturasGenericas.Descripcion, 
                      dbo.vwrTiposEspaciosCurriculares.Descripcion AS TipoEspCurricular, dbo.tb_AsignaturasGenericas.Mnemo, dbo.tb_AsignaturasGenericas.Baja
FROM         dbo.tb_AsignaturasGenericas INNER JOIN
                      dbo.vwrTiposEspaciosCurriculares ON dbo.tb_AsignaturasGenericas.Tipo = dbo.vwrTiposEspaciosCurriculares.ID
WHERE     (dbo.tb_AsignaturasGenericas.Baja = 'N')
GO
GRANT SELECT ON  [dbo].[vwlAsignaturasGenericas] TO [Juntas]
GRANT SELECT ON  [dbo].[vwlAsignaturasGenericas] TO [RegistroTitulos]
GRANT SELECT ON  [dbo].[vwlAsignaturasGenericas] TO [SoloVer]
GO
